<%@ page import=" java.util.Date, 
			java.sql.Connection, java.sql.PreparedStatement,
 			java.sql.ResultSet, java.text.SimpleDateFormat, 
 			java.util.TimeZone;" language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
    <jsp:useBean id="member" class="com.kamikaze.Member" scope="session" />
    <jsp:useBean id="leave" class="com.kamikaze.Leave" scope="session" />
<%
java.util.Date now = new java.util.Date(); //取得現在時間
SimpleDateFormat dd = new SimpleDateFormat("yyyy-MM-dd");
String day = dd.format(now);
%>

<sql:update var="r" dataSource="jdbc/j2db">
UPDATE  `j2`.`leavedata` SET  `approved` =  '1',`checker_id`=?
WHERE  `leavedata`.`leaved_number` =?
<sql:param>${member.user_id }</sql:param>
<sql:param>${param.id }</sql:param>
</sql:update>




<%
response.sendRedirect("index.jsp?f=13");
%>
